﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SQLite;



namespace CH.Study.ConsoleApp.SqlLite
{
   public class SqlLiteTest:ITest
    {
        public void Start()
        {
            string dbPath = AppDomain.CurrentDomain.BaseDirectory + @"SQLite\Northwind.db";
            using (SQLiteConnection connection = new SQLiteConnection("Data Source=" + dbPath))
            {
          
                connection.Open();
                using (SQLiteCommand command = new SQLiteCommand(connection))
                {
                    command.CommandText = "SELECT * FROM Customers";
                    SQLiteDataAdapter adapter = new SQLiteDataAdapter(command);
                    DataTable dt = new DataTable();
                    adapter.Fill(dt);

                }
            }
        }

        
       
    }
}
